USE [MMS]
GO

/****** Object:  Trigger [dbo].[TR_AS_UPDATE_ASSET]    Script Date: 12/03/2012 23:07:24 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TRIGGER [dbo].[TR_AS_UPDATE_ASSET] ON [dbo].[MMS_ASSET] 
  AFTER UPDATE AS
BEGIN

  SET NOCOUNT ON;
  UPDATE [dbo].[MMS_ASSET] 
  SET UpdateDate = getdate() 
  WHERE id = (select id from inserted)

END
GO